Importing and Exporting ADO Client Data Sources

The SequeLink Data Source SyncTool allows you to export ADO client data source definitions to data source files and distribute them to multiple end users. The SequeLink Data Source SyncTool provides two user implementations, one for the SequeLink administrator and another for the end user:

The SequeLink for ADO Data Source SyncTool Administrator is used by the SequeLink administrator to create data source files. It can import and export data sources. This tool should be made available to the SequeLink administrator only.
The SequeLink for ADO Data Source SyncTool is used by the end user and can import data sources only. It should be installed on every SequeLink Client for ADO.

In addition, you can create a customized, installable image of SequeLink Client for ADO with predefined, site-specific settings, including data source files created with the SequeLink Data Source SyncTool. This customized, installable image is called a Quick Install image. For more information about creating Quick Install images, refer to the SequeLink Installation Guide.

The window title bar of the SequeLink Data Source SyncTool indicates whether you, or the end user, is performing an export or an import operation. Also, context-sensitive online help is available by clicking ? on the title bar; then, clicking the area about which you want more information.

Exporting ADO Client Data Sources

From the SequeLink program manager group, double-click the ADO Data Source SyncTool Administrator icon. The SequeLink for ADO Data Source SyncTool Administrator Welcome window appears.
Select the Manage Data Sources Files option; then, click Next.
Select a data source file from the Filename list box, or click Browse to find a data source file not listed. The default extension for data source files is .OSF.

To create a new data source file, click New.

Select whether you want to export User or System data sources to the data source file you selected; then click Next.
Select the data sources you want to export to the data source file.

NOTE: You cannot export grayed-out data sources, which are data sources that are configured for a previous incompatible version of the ADO provider.

Using the following symbols, verify that the appropriate actions will be performed on the data sources in the data source file:

	The data source will remain unchanged.
	The data source will be added to the data source file.
	The data source will be deleted from the data source file.
	The data source will be updated in the data source file.

Type a description for the data source file; then, click Next. This description will appear when the end user selects this file for importing.
Select the mode the end user will use to import these data sources; then, click Next.
Interactive mode allows the user to select which data sources will be imported. This mode is not supported by the Quick Install feature; the Quick Install feature supports only data source files created with the Merge or Overwrite options. For instructions on creating Quick Install images, refer to the SequeLink Installation Guide.
Merge mode adds or updates all the data sources in the data source file without deleting other data sources.
Overwrite mode adds or updates the data sources in the data source file and deletes any other data sources configured for the ADO provider.
Select the option that will determine how the end user will be able to import the data sources you exported to the data source file; then, click Next.
Suggest SequeLink User DSN. When imported, the SequeLink for ADO Data Source SyncTool will suggest to the end user that these data sources be imported as User data sources, but will allow them to be imported as User or System data sources.
Suggest SequeLink System DSN. When imported, the SequeLink for ADO Data Source SyncTool will suggest to the end user that these data sources be imported as System data sources, but will allow them to be imported as User or System data sources.
Force SequeLink User DSN. When imported, the SequeLink for ADO Data Source SyncTool will allow these data sources to be imported as User data sources only.
Force SequeLink System DSN. When imported, the SequeLink for ADO Data Source SyncTool will allow these data sources to be imported as System data sources only.
Click Finish to quit.

Importing ADO Client Data Sources

The SequeLink administrator and end user use a slightly different implementation of the SequeLink for ADO Data Source SyncTool to import ADO data source definitions.

To import ADO client data sources:

From the SequeLink program manager group, double-click the appropriate ADO SyncTool icon. The Welcome window appears.
Select the Import option; then, click Next.

NOTE: If using the SequeLink for ADO Data Source SyncTool Administrator, select the Import Data Sources option, and click Next.

Select a data source file from the Filename list box, or click Browse to find a data source file not listed. The default extension for data source files is .OSF.
Verify that the appropriate actions will be performed on the data sources on your local machine; then, click Next. Depending on the import mode that was set when the data source file was exported, you may see the following symbols:

	The data source will remain unchanged.
	The data source will be added to your local machine.
	The data source will be deleted from your local machine.
	The data source will be updated to your local machine.

NOTE: Grayed-out data sources are data sources that are configured for a previous incompatible version of the ADO provider; these data sources will remain unchanged unless you update them in Interactive mode with a data source configured for the current version of the ADO provider.

Click Finish to quit.